package com.novoda.runbuddy.provider;

public class GeoPointsDBSQL {

	public static final String	CHECKPOINT_ID					= "_idCheckPoint";
	public static final String	CHECKPOINT_SID					= "__id";
	public static final String	CHECKPOINT_GEOLOCATION_ID		= "_idGeoLocation";
	public static final String	CHECKPOINT_NAME					= "name";
	public static final String	CHECKPOINT_DESC					= "desc";
	public static final String	CHECKPOINT_IMPLEMENTOR			= "implementor";
	public static final String	CHECKPOINT_CREATED_AT			= "createdAt";
	public static final String	CHECKPOINT_MODIFIED_AT			= "modifiedAt";

	public static final String	GEOLOCATION_ID					= "_id";
	public static final String	GEOLOCATION_NAME				= "name";
	public static final String	GEOLOCATION_ADDRESS1			= "address1";
	public static final String	GEOLOCATION_ADDRESS2			= "address2";
	public static final String	GEOLOCATION_POSTOCODE			= "postcode";
	public static final String	GEOLOCATION_COUNTRY_CODE		= "countryCode";
	public static final String	GEOLOCATION_LONGITUDE			= "longitude";
	public static final String	GEOLOCATION_LATITUDE			= "latitude";
	public static final String	GEOLOCATION_ALTITUDE			= "altitude";
	public static final String	GEOLOCATION_MODIFIED_AT			= "modifiedAt";
	public static final String	GEOLOCATION_CREATED_AT			= "createdAt";

	public static String[]		COLUMNS_IN_CHECKPOINT_ENTRY		= new String[] { CHECKPOINT_ID, CHECKPOINT_SID,
			CHECKPOINT_GEOLOCATION_ID, CHECKPOINT_NAME, CHECKPOINT_DESC, CHECKPOINT_IMPLEMENTOR, CHECKPOINT_CREATED_AT,
			CHECKPOINT_MODIFIED_AT								};

	public static String[]		COLUMNS_IN_GEOLOCATION_ENTRY	= new String[] { GEOLOCATION_ID, GEOLOCATION_NAME,
			GEOLOCATION_ADDRESS1, GEOLOCATION_ADDRESS2, GEOLOCATION_POSTOCODE, GEOLOCATION_COUNTRY_CODE, GEOLOCATION_LONGITUDE,
			GEOLOCATION_LATITUDE, GEOLOCATION_ALTITUDE, GEOLOCATION_CREATED_AT, GEOLOCATION_MODIFIED_AT };
}
